Data Analytics for Undergraduate Tax Students: An Alteryx Case Study for MACRS Depreciation

ABSTRACT The increasing use of data analytics in the accounting profession necessitates development instructional cases that teach students how to tools solve common problems. While there has been an emphasis on for graduate education, we recognized a need such at undergraduate level prepare internships, careers, and education. This case meets this important by introducing Alteryx typical tax setting—the calculation Modified Accelerated Cost Recovery System (MACRS) depreciation. learning objectives are to: (1) extend knowledge analytics; (2) develop skills using extract, transform, load data; (3) demonstrate understanding rules computing depreciation; (4) effective written communication skills.